CIMPLICITY REST API Web Service
CIMPLICITY REST API Web Service / SQLGetResponse Json Schema
In This Topic
    SQLGetResponse Json Schema
    In This Topic
    Description
    The results of the points get query
    Overview
    SQLGetResponse
    The results of the points get query
    SQLDefaultConnections : Array[CimSQLConnection]
    An array of the CimSQLConnection objects to create/update.
    ConnectionType : CimSQLConnectionType
    ODBCDataSource : string
    ODBC Data connection.
    UserID : string
    User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
    Passsword : string
    Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
    ReconnectWaitPeriod : integer
    The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
    ReconnectWaitUnit : CimTimeUnitEnum
    defines units for time values
    EnableStoreAndForward : boolean
    Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
    MaxNumberOfStoredRecord : number
    To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
    SQLTableConnections : Array[CimSQLTableConnection]
    An array of the CimSQLConnection objects to create/update.
    Table_id : string
    Table id on which connection is updated.
    SQLConnection : CimSQLConnection
    Fields that describe the connection to a SQL connection
    ConnectionType : CimSQLConnectionType
    ODBCDataSource : string
    ODBC Data connection.
    UserID : string
    User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
    Passsword : string
    Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
    ReconnectWaitPeriod : integer
    The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
    ReconnectWaitUnit : CimTimeUnitEnum
    defines units for time values
    EnableStoreAndForward : boolean
    Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
    MaxNumberOfStoredRecord : number
    To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
    Properties
    NameDescriptionData Type
    SQLDefaultConnectionsAn array of the CimSQLConnection objects to create/update.Array[CimSQLConnection]
    SQLTableConnectionsAn array of the CimSQLConnection objects to create/update.Array[CimSQLTableConnection]
    See Also
    CIMPLICITY REST API Web Service

     

     

    © 2021 All Rights Reserved.